package com.qlzb.taskmanagement.persistentData.dao;

import com.qlzb.taskmanagement.persistentData.entity.OperationWorkOrder;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.repository.CrudRepository;
import org.springframework.transaction.annotation.Transactional;

@Transactional
public interface OperationWorkOrderDao extends CrudRepository<OperationWorkOrder,Integer>, JpaSpecificationExecutor {
    public void deleteByCreateTimeBefore(String createTime);
    public void deleteByCityId(String cityid);
    public int countByTroubleTicketNo(String troubleTicketNo);
    Page<OperationWorkOrder> findAll(Pageable pageable);
}
